UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XSLhF6u2jD0K7BDwQzoHqksHuNUzQrFpMDqG/bq4Ea0='
WHERE
key_id = 'd40077da74cf0b1a0586a3062875821a3728d97322eb9d787af692843b615d70'
AND (
token = 'XSLhF6u2jD0K7BDwQzoHqksHuNUzQrFpMDqG/bq4Ea0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)