UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I3nT7pDAKDE4qpyGG0mfYXZ8YnswdGFrTFeBU5s+R6Q='
WHERE
key_id = 'aaa1e33ff96529ded5c8329b2bf8a0e02027cfb6b35b41409a667eb221f57988'
AND (
token = 'I3nT7pDAKDE4qpyGG0mfYXZ8YnswdGFrTFeBU5s+R6Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)