UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LZuRZs9c0GHtD3wAp15rCC6hXYqeQsAyM00fyGNHbws='
WHERE
key_id = 'e7223a14f5800961b2619e64caa643e265cbac0fc60829f37ae36d31dceb9a3c'
AND (
token = 'LZuRZs9c0GHtD3wAp15rCC6hXYqeQsAyM00fyGNHbws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)