UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6AiMNL2ISH5L3vOwmy1Na7kPHA5TztSvw7zNVbHyAC4='
WHERE
key_id = '28242acfd2d4876ca90436b628bace67d869af974a9d6551869563a8bb23a464'
AND (
token = '6AiMNL2ISH5L3vOwmy1Na7kPHA5TztSvw7zNVbHyAC4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)