UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZOsK4sftX7ynwvEMxI0uOFjeCf5C+3gZ/+wDkV6QVFw='
WHERE
key_id = '5703f9567bc5fc8b0def3f12b19cba57d7f986722212ecf34fc2448d29620963'
AND (
token = 'ZOsK4sftX7ynwvEMxI0uOFjeCf5C+3gZ/+wDkV6QVFw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)