UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZAUi4/GEaDpKiwiNZ4gPwOpLWvhqI8RO9+HoOZHeg5U='
WHERE
key_id = 'bed0afb7057ba62039b8b23e9a5bc49ef4cbae6e4c8528bd3e222427b9abe9d6'
AND (
token = 'ZAUi4/GEaDpKiwiNZ4gPwOpLWvhqI8RO9+HoOZHeg5U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)