UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X4lpX0CS1xd/98EAafNk3Z91StmJr1ZjPAU2R10MKLE='
WHERE
key_id = '3d995d27953ddd9376dc78c1d0eb7900b6aae82d7f1f6638c264d4133e6e89b5'
AND (
token = 'X4lpX0CS1xd/98EAafNk3Z91StmJr1ZjPAU2R10MKLE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)