UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9ZKpgatkn/3meV1muXSa4SfDb/vcPiiuH0zwdH34cKs='
WHERE
key_id = 'daf76f5265ac2eab473beb4d1b8af3981fa575e085298496aefba128661920ab'
AND (
token = '9ZKpgatkn/3meV1muXSa4SfDb/vcPiiuH0zwdH34cKs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)