UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PNt4jWe0qMAjfX3i2pqJuH4cgeAUr6m4R30oduxxba8='
WHERE
key_id = '29efd15d1e988ece6263b55d5032e3b99e5693524e2b6f5f1376b288dc092410'
AND (
token = 'PNt4jWe0qMAjfX3i2pqJuH4cgeAUr6m4R30oduxxba8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)