UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6hlz9ACc3M5GShrzq4JdVE3Hg+dtZUKyjyvNv0jq4WQ='
WHERE
key_id = 'ea67b120165fb0c31ec93621831b1ceab0a9a4b998cc4179bb2c555707be9bd0'
AND (
token = '6hlz9ACc3M5GShrzq4JdVE3Hg+dtZUKyjyvNv0jq4WQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)