UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LQNO1hAgsYQeWeQ4aTF7neNl3kTUbLuNBRL+Hp133Os='
WHERE
key_id = '47e6d350a6151a2b1199936de840d53406a8605652dd2a278a56355aff38730a'
AND (
token = 'LQNO1hAgsYQeWeQ4aTF7neNl3kTUbLuNBRL+Hp133Os='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)