UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U1f12dIrEHz5G0rt9zcR2TE50BpdSCJSnMi7JhDrwZs='
WHERE
key_id = 'e16991d20381b069bf2e38fb3705242206a56559010c766e152f994d9e2d425f'
AND (
token = 'U1f12dIrEHz5G0rt9zcR2TE50BpdSCJSnMi7JhDrwZs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)