UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zAOeDr7p1DaJuxyPAEONBlW5kbi5/w6YXre3qA6AUxQ='
WHERE
key_id = '9be3898416a5544b54bc666a212f6b37bf733788d77fd925465374a3a48242de'
AND (
token = 'zAOeDr7p1DaJuxyPAEONBlW5kbi5/w6YXre3qA6AUxQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)