UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8dqKumQSN7I95HxmXq/ZLhw1LdGEBuT/o8Gh7qwqKL0='
WHERE
key_id = 'd48c3193b076480eca2d86fa52f0c692fa7d21296a415d787188676cea85a594'
AND (
token = '8dqKumQSN7I95HxmXq/ZLhw1LdGEBuT/o8Gh7qwqKL0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)