UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3jjKZVqZitAN/iYSGL+4M7Y6VJD9GOdItdgse7Iznx8='
WHERE
key_id = 'ef92327989c31c30797e450ae11e8e14ab66203c4b4236e121fe65bbe8c39f50'
AND (
token = '3jjKZVqZitAN/iYSGL+4M7Y6VJD9GOdItdgse7Iznx8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)