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