UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NBiwZHnh865rTqpV/ZtqJj/qSP3dd4L/hL8eEpLN2F4='
WHERE
key_id = 'b793b43acfdcaa535b257fa30356971197b625f697d94e8c93bfd27d40f57ff9'
AND (
token = 'NBiwZHnh865rTqpV/ZtqJj/qSP3dd4L/hL8eEpLN2F4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)