UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6BDZKboms02cQTdl9Wju1hfC+dnkVX7l+8MbS4hitPg='
WHERE
key_id = '5cd9c1e5325e3e5d845dc1843fa689a039cff2338f19499a43d6d523dac4f64d'
AND (
token = '6BDZKboms02cQTdl9Wju1hfC+dnkVX7l+8MbS4hitPg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)