UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mqR+JF7sPhJmZ5Cja8jxIQ8usYjHUbqxW/a3ON4obwA='
WHERE
key_id = 'f8219f95760e1b54f5a849d4106a96e3c07977c319741f6a6c73a7c54122bece'
AND (
token = 'mqR+JF7sPhJmZ5Cja8jxIQ8usYjHUbqxW/a3ON4obwA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)