UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xgU88LQJ9vwbzVDOfcPb6siVHBoXAJUW12gUSNWnMhs='
WHERE
key_id = 'b554ef81171140cec4f983e32072c170611f5a9c8652fbaa249457c2ac44d4dc'
AND (
token = 'xgU88LQJ9vwbzVDOfcPb6siVHBoXAJUW12gUSNWnMhs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)