UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8ZKOLyZ50BH0uAICJuGn8Aqhpq7Nfiw/W1fyq/M7fLw='
WHERE
key_id = '6d75bf29c9be7a13426145e51e27c2b1273cc22cd14eff7d32267ac021094bbb'
AND (
token = '8ZKOLyZ50BH0uAICJuGn8Aqhpq7Nfiw/W1fyq/M7fLw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)