UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'onDsYSf3WXwvVrDF2GkElsWuJNKscT3+oQLLDBA00+g='
WHERE
key_id = 'd5ff50bb3285c5f6579d85d36d17c8f92a1af9a9e8239c3276a54a729b6bd270'
AND (
token = 'onDsYSf3WXwvVrDF2GkElsWuJNKscT3+oQLLDBA00+g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)