UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5aFfbai/5TUYqvrAh76LAXt0XOCfMX+aei3G1Xnwtvc='
WHERE
key_id = 'a76596b6912318254667791c16f7284cb23b094b7388a21c3e339d4d1d87bb9c'
AND (
token = '5aFfbai/5TUYqvrAh76LAXt0XOCfMX+aei3G1Xnwtvc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)