UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xjlh7Mvbw794HxqUOQU44QVZy4oI4prgMVV2HNCX+gk='
WHERE
key_id = 'dc661ad15cf1a0a6e6c827e59f78722a8974ac443efad117b06790dd53d58156'
AND (
token = 'Xjlh7Mvbw794HxqUOQU44QVZy4oI4prgMVV2HNCX+gk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)