UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YdMzFDtnkXwoz8/WqJoDIa+zurRLFPaYWMGlf1aS/uo='
WHERE
key_id = 'c375e7a012f1c52d3696ecff6729bf50f6e485bd7d642e1be3be2103e09d4fce'
AND (
token = 'YdMzFDtnkXwoz8/WqJoDIa+zurRLFPaYWMGlf1aS/uo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)