UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4qdh/niRqlaNBvhOZ7cmoH6e7SXH0aPtImjx2WjEsLs='
WHERE
key_id = '6b54296e28e88224c7818873b62d9d513faefedacb5b67de2ba507f8886d66f9'
AND (
token = '4qdh/niRqlaNBvhOZ7cmoH6e7SXH0aPtImjx2WjEsLs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)