UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zl8AXrF6xwfEmLOWHbXp1ehV4cUmEhgEtJ7PoemVUHg='
WHERE
key_id = '4ebf7e3814c93bd6668790344e77e53d744602347032979342ef192e1fa2f7df'
AND (
token = 'zl8AXrF6xwfEmLOWHbXp1ehV4cUmEhgEtJ7PoemVUHg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)