UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '78SE5eYh/+wgIGXKsfrfeulhep2qq/Nex4mA4zu9erU='
WHERE
key_id = 'a94f6bf1f9deb285695377a98e721d87db4b58bb67c76a6a731ea57655a61238'
AND (
token = '78SE5eYh/+wgIGXKsfrfeulhep2qq/Nex4mA4zu9erU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)