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