UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7Chh/JcZp5+NKzgar9GA7MbD895D4AffdhJ8StGmlZQ='
WHERE
key_id = '7a83edcee9fb1a189514b36ef2fc121249d431e62d4793adb7feff5a62d02ea3'
AND (
token = '7Chh/JcZp5+NKzgar9GA7MbD895D4AffdhJ8StGmlZQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)