UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VdDqKegXDxviomjJv2cdi25MYgtORLB1valGNu8DzMU='
WHERE
key_id = '1e024962fe50c6916556c2f095a68c2e33d26f94d78fd6c214b35f8b92f4562b'
AND (
token = 'VdDqKegXDxviomjJv2cdi25MYgtORLB1valGNu8DzMU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)