UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QsR2gJM6xOc9his/75qB2Kt7QBZgpLukyfPFXDcxHSs='
WHERE
key_id = '002bc91ffaa8675aa86fa16c504c346c4c459ca5fb45ea16fb0dd54c6563ba0b'
AND (
token = 'QsR2gJM6xOc9his/75qB2Kt7QBZgpLukyfPFXDcxHSs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)