UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3Sn6UL92JOPCZkbIxWcXNoOAGqUC1zRbl9wSO7dwvho='
WHERE
key_id = '0296eabf5e7eccd850f819a9d08b1608d64683e5df03e0aef0d86d611ca4f05e'
AND (
token = '3Sn6UL92JOPCZkbIxWcXNoOAGqUC1zRbl9wSO7dwvho='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)