UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w8a17VgdJp9ZCCOG3INJpW7GV86WhGhSKQysmhxAStM='
WHERE
key_id = '92bbdb0dc13ea6aa494ca78f90b68a38672b6f8b02e2f685bb095747a0ff1599'
AND (
token = 'w8a17VgdJp9ZCCOG3INJpW7GV86WhGhSKQysmhxAStM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)