UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V+s4lzjRgY0ehW9kLapz3ICPlsr0bEnVhuZQzdoF89I='
WHERE
key_id = 'f45f83e3e510404c385a87663477c33bc2ce4ee9bb4cd0392f56818a773d71ca'
AND (
token = 'V+s4lzjRgY0ehW9kLapz3ICPlsr0bEnVhuZQzdoF89I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)